Columns

Indexes

Grants

Dependencies

Details


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
OBJ VARCHAR2(20 BYTE) No null 1 null
ID VARCHAR2(100 BYTE) Yes null 2 null
TITLE VARCHAR2(400 BYTE) Yes null 3 null
CREATED_ON DATE Yes null 4 null
CREATED_ON_FY NUMBER Yes null 5 null
CLOSED_ON DATE Yes null 6 null
CLOSED_ON_FY NUMBER Yes null 7 null
DAYS_OPEN NUMBER Yes null 8 null
STATUS VARCHAR2(100 BYTE) Yes null 9 null
OWNING_UNIT VARCHAR2(400 BYTE) Yes null 10 null
INCIDENTS VARCHAR2(4000 BYTE) Yes null 11 null
LEAD VARCHAR2(400 BYTE) Yes null 12 null
SUPPORT_PERSONNEL VARCHAR2(4000 BYTE) Yes null 13 null
ASSOCIATIONS_COUNT NUMBER Yes null 14 null
ATTACHMENTS_COUNT NUMBER Yes null 15 null
NOTES_COUNT NUMBER Yes null 16 null
SUBJECT_COUNT NUMBER Yes null 17 null
WITNESS_COUNT NUMBER Yes null 18 null
VICTIM_COUNT NUMBER Yes null 19 null
INCIDENTAL_COUNT NUMBER Yes null 20 null
NEXT_DUE_DATE DATE Yes null 21 null
FINAL_DUE_DATE DATE Yes null 22 null
FINAL_DUE_DATE_FY NUMBER Yes null 23 null
FINAL_DUE_DATE_MET VARCHAR2(3 BYTE) Yes null 24 null
INDEX_OWNER INDEX_NAME COLUMNS UNIQUENESS STATUS INDEX_TYPE TEMPORARY PARTITIONED FUNCIDX_STATUS COLUMN_EXPRESSION JOIN_INDEX




PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OBJECT_ID OWNER OBJECT_TYPE OBJECT_NAME STATUS TYPE_LINK



References


NAME VALUE
CREATED 24-APR-23
LAST_DDL_TIME 07-FEB-25
OWNER QART
MVIEW_NAME MV_SIIA_ANALYSIS
CONTAINER_NAME MV_SIIA_ANALYSIS
QUERY SELECT DISTINCT             O.SID OBJ,             O.ID ID,             O.TAGLINE TITLE,             O.CREATED_ON CREATED_ON,             O.CREATED_ON_FY CREATED_ON_FY,             CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON ELSE NULL END              AS CLOSED_ON,             CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON_FY ELSE NULL END              AS CLOSED_ON_FY,             CASE             WHEN S1.DISPLAY = 'Closed'               THEN                (TRUNC (S.STARTED_ON) - TRUNC (O.CREATED_ON))             ELSE                (TRUNC (SYSDATE) - TRUNC (O.CREATED_ON))             END              DAYS_OPEN,             S1.DISPLAY STATUS,             OU.SH_DISPLAY OWNING_UNIT,             LISTAGG (REF.DISPLAY, ', ') WITHIN GROUP (ORDER BY REF.DISPLAY)                INCIDENTS,             L.SH_DISPLAY LEAD,             SO.SH_DISPLAY SUPPORT_PERSONNEL,             NVL(FROM_ASSOC_COUNT.CNT, 0) + NVL(TO_ASSOC_COUNT.CNT, 0) ASSOCIATIONS_COUNT,             NVL(ATTACH_COUNT.CNT, 0) ATTACHMENTS_COUNT,             NVL(NOTES_CNT.CNT, 0) NOTES_COUNT,             NVL(SUBJ_COUNT.CNT, 0) SUBJECT_COUNT,             NVL(WIT_COUNT.CNT, 0) WITNESS_COUNT,             NVL(VIC_COUNT.CNT, 0) VICTIM_COUNT,             NVL(INC_COUNT.CNT, 0) INCIDENTAL_COUNT,             O.NEXT_DUE_DATE,             O.FINAL_DUE_DATE,             O.FINAL_DUE_DATE_FY,             CASE                WHEN S1.DISPLAY = 'Closed'                     AND TRUNC (S.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE)                THEN                   'Yes'                ELSE                   'No'             END                FINAL_DUE_DATE_MET        FROM MV_ACM_OBJ O             INNER JOIN MV_ACM_OBJ_TYPE OT                ON O.OBJ_TYPE = OT.SID AND OT.OBJ_TYPE_CODE = 'FILE.ANALYSIS'             LEFT JOIN MV_F_ANALYSIS ANALYSIS                ON O.SID = ANALYSIS.OBJ             LEFT JOIN MV_F_ANALYSIS_INC ANALYSIS_INC                ON ANALYSIS.SID = ANALYSIS_INC.ANALYSIS_FILE             LEFT JOIN MV_ACM_REFERENCE REF                ON REF.REF_KEY = ANALYSIS_INC.MATTER_INVEST             LEFT JOIN MV_ACM_STATUS_HISTORY S                ON O.SID = S.OBJ AND S.COMPLETED_ON IS NULL             LEFT JOIN MV_ACM_STATUS S1                ON S1.SID = S.STATUS             LEFT JOIN MV_ACM_PLACE V                ON O.SID = V.OBJ             LEFT JOIN V_CURR_OBJ_OWNING_UNIT OU                ON O.SID = OU.OBJ             LEFT JOIN V_CURR_OBJ_LEAD_PERS L                ON O.SID = L.OBJ             LEFT JOIN (SELECT OBJ,                               LISTAGG (SH_DISPLAY, ';' || CHR (13))                                  WITHIN GROUP (ORDER BY SH_DISPLAY)                                  OVER (PARTITION BY OBJ)                                  SH_DISPLAY                          FROM V_CURR_OBJ_SUPPORT_OFFICER) SO                ON O.SID = SO.OBJ LEFT JOIN (SELECT FROM_OBJ, COUNT (1) AS CNT                FROM MV_ACM_ASSOCIATION GROUP BY FROM_OBJ) FROM_ASSOC_COUNT     ON FROM_ASSOC_COUNT.FROM_OBJ = O.SID LEFT JOIN (SELECT TO_OBJ, COUNT (1) AS CNT                FROM MV_ACM_ASSOCIATION GROUP BY TO_OBJ) TO_ASSOC_COUNT     ON TO_ASSOC_COUNT.TO_OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_ACM_ATTACHMENT GROUP BY OBJ) ATTACH_COUNT    ON ATTACH_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_ACM_NOTE GROUP BY OBJ) NOTES_CNT    ON NOTES_CNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_PARTIC_INVOLVEMENT               WHERE INVOLVEMENT_ROLE IN (SELECT SID                                                FROM MV_PARTIC_ROLE_TYPE                                               WHERE CODE = 'SUBJECT') GROUP BY OBJ) SUBJ_COUNT ON SUBJ_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_PARTIC_INVOLVEMENT               WHERE INVOLVEMENT_ROLE IN (SELECT SID                                                FROM MV_PARTIC_ROLE_TYPE                                               WHERE CODE = 'WITNESS') GROUP BY OBJ) WIT_COUNT ON WIT_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_PARTIC_INVOLVEMENT               WHERE INVOLVEMENT_ROLE IN (SELECT SID                                                FROM MV_PARTIC_ROLE_TYPE                                               WHERE CODE = 'VICTIM') GROUP BY OBJ) VIC_COUNT ON VIC_COUNT.OBJ = O.SID LEFT JOIN (SELECT OBJ, COUNT (1) AS CNT                FROM MV_PARTIC_INVOLVEMENT               WHERE INVOLVEMENT_ROLE IN (SELECT SID                                                FROM MV_PARTIC_ROLE_TYPE                                               WHERE CODE = 'INCDNTL') GROUP BY OBJ) INC_COUNT ON INC_COUNT.OBJ = O.SID    GROUP BY O.SID,     O.ID,     OT.DISPLAY,     O.TAGLINE,     O.CREATED_ON,    S1.DISPLAY,     OU.SH_DISPLAY,     L.SH_DISPLAY,     SO.SH_DISPLAY,     NVL(FROM_ASSOC_COUNT.CNT, 0) + NVL(TO_ASSOC_COUNT.CNT, 0),    NVL(ATTACH_COUNT.CNT, 0),    NVL(NOTES_CNT.CNT, 0),    NVL(SUBJ_COUNT.CNT, 0),    NVL(WIT_COUNT.CNT, 0),    NVL(VIC_COUNT.CNT, 0),    NVL(INC_COUNT.CNT, 0),    O.CREATED_ON_FY,     O.NEXT_DUE_DATE,     O.FINAL_DUE_DATE,     O.FINAL_DUE_DATE_FY,     CASE WHEN S1.DISPLAY = 'Closed' AND TRUNC (S.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE) THEN 'Yes' ELSE 'No' END,     S1.DISPLAY,     'Closed',     TRUNC (S.STARTED_ON),     CASE WHEN S1.DISPLAY = 'Closed' THEN (TRUNC (S.STARTED_ON) - TRUNC (O.CREATED_ON)) ELSE (TRUNC (SYSDATE) - TRUNC (O.CREATED_ON)) END,     S.STARTED_ON,     TRUNC (O.FINAL_DUE_DATE),     O.FINAL_DUE_DATE,     'Yes', 'No',     S1.DISPLAY,     'Closed',     TRUNC (S.STARTED_ON),     S.STARTED_ON,     S.STARTED_ON,     TRUNC (O.FINAL_DUE_DATE),     O.FINAL_DUE_DATE,     O.FINAL_DUE_DATE,     'Yes', 'No',     CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON ELSE NULL END,     S1.DISPLAY,     'Closed',     S.STARTED_ON,     NULL,     CASE WHEN S1.DISPLAY = 'Closed' THEN S.STARTED_ON_FY ELSE NULL END,     S1.DISPLAY,     'Closed',     S.STARTED_ON_FY,     NULL
QUERY_LEN 6069
UPDATABLE N
UPDATE_LOG null
MASTER_ROLLBACK_SEG null
MASTER_LINK null
REWRITE_ENABLED N
REWRITE_CAPABILITY NONE
REFRESH_MODE DEMAND
REFRESH_METHOD FORCE
BUILD_MODE IMMEDIATE
FAST_REFRESHABLE NO
LAST_REFRESH_TYPE COMPLETE
LAST_REFRESH_DATE 07-FEB-25
LAST_REFRESH_END_TIME 07-FEB-25
STALENESS UNUSABLE
AFTER_FAST_REFRESH NA
UNKNOWN_PREBUILT N
UNKNOWN_PLSQL_FUNC N
UNKNOWN_EXTERNAL_TABLE N
UNKNOWN_CONSIDER_FRESH N
UNKNOWN_IMPORT N
UNKNOWN_TRUSTED_FD N
COMPILE_STATE VALID
USE_NO_INDEX N
STALE_SINCE null
NUM_PCT_TABLES 0
NUM_FRESH_PCT_REGIONS null
NUM_STALE_PCT_REGIONS null
SEGMENT_CREATED YES
EVALUATION_EDITION null
UNUSABLE_BEFORE null
UNUSABLE_BEGINNING null
DEFAULT_COLLATION USING_NLS_COMP
ON_QUERY_COMPUTATION N
DUPLICATED N
SHARDED N